MS Excel Practice Questions
In this series of blogs, we will post MS Excel Practice Questions. These questions will be helpful for the candidates who have attended our MS Excel training as well as others who wish to learn and practice.
This first section covers the overview of MS Excel and contains basic concepts, in the subsequent blogs we will be covering more advanced techniques. Explore more by practicing questions on Conditional formatting in excel.
New to Excel? Watch our Free Excel for Beginners Playlist on YouTube to get started with step-by-step video tutorials.
Ques1. Create the following sheet in MS Excel. Format the sheet exactly the way shown below.
Ques 2. What is the address (Row/Column) of Product ID = 4, Sub-Category = Chairs
Ques 3. How can we see the data only for Category = Furniture. See the screen shot below for the output.
Ques 4. Refer to the data in screen shot Figure1. Sort Sub-Category from in alphabetical order. Refer to the screen shot below for the output.
Ques 5. What option you will choose to search Chairs in the entire data set.
Ques 6. Create an exact copy of the worksheet you are working on. Mention the steps/options you will take to achieve this.
Ques 7. Create a heading above the dataset, the way it is shown in the screenshot below.
Ques 8. Do not display the Discount column in the data shown above in Figure4. Make sure not to delete it. Refer to the screen shot below for the output.
Ques 9. In the above sheet, on any empty cell enter a word – MS Excel. Link it to the url https://en.wikipedia.org/wiki/Microsoft_Excel. Refer to the screen shot below.
Click here to look for questions on Conditional formatting in excel.
For a step-by-step approach to learning more advanced features in Excel, take a look at the book Excel Basics to Advanced.
Microsoft Excel is widely used with Business Intelligence applications such as Tableau and Power BI. Learn about Tableau and start your journey by creating your first visualization in Tableau.
Explore more Excel blogs
Feel free to post your comments in the comment section of this blog.
New to Excel? Want to see Excel in action? Watch the full Excel for Beginners Playlist here:
About the Author
Chandraish Sinha is the Founder and President of Ohio Computer Academy, a leading institution committed to delivering high-quality IT education. With a passion for teaching and a belief in his company’s mission—Inspire, Educate & Evolve—Chandraish brings over 25 years of experience in the Information Technology industry.
He is a prolific author, having published multiple books on Business Intelligence tools such as Tableau, Power BI, Qlik and other technologies. His most recent books include:
- IT Career Guide for Beginners: Steps to Launch and Develop a Successful Career in Information Technology
- Tableau for Job Seekers
- Excel Basics to Advanced – a comprehensive self-learning guide for mastering Microsoft Excel
- Dashboarding with Tableau – covering essential features and exercises for hands-on learning
Chandraish has successfully implemented IT solutions across diverse domains including pharmaceuticals, healthcare, telecom, finance, and retail. He actively blogs on trending IT topics and training strategies:
👉 Check out his latest posts:
Explore more of his work on his Amazon Author Profile.
